5 * @subpackage SpecialPage
9 * Entry point : initialise variables and call subfunctions.
10 * @param string $par ????? (default NULL)
12 function wfSpecialAllpages( $par=NULL ) {
13 global $indexMaxperpage, $toplevelMaxperpage, $wgRequest, $wgOut, $wgContLang;
15 $indexMaxperpage = 480;
16 $toplevelMaxperpage = 50;
18 $from = $wgRequest->getVal( 'from' );
19 $namespace = $wgRequest->getInt( 'namespace' );
20 $invert = $wgRequest->getBool( 'invert' );
22 $names = $wgContLang->getNamespaces();
24 if( !isset( $names[$namespace] ) ) {
29 $wgOut->setPagetitle( $namespace > 0 ?
30 wfMsg( 'allnotinnamespace', $names[$namespace] ) :
31 wfMsg( 'allnonarticles' )
34 $wgOut->setPagetitle( $namespace > 0 ?
35 wfMsg( 'allinnamespace', $names[$namespace] ) :
36 wfMsg( 'allarticles' )
41 indexShowChunk( $namespace, $par, $invert );
43 indexShowChunk( $namespace, $from, $invert );
45 indexShowToplevel ( $namespace, $invert );
50 * HTML for the top form
51 * @param integer $namespace A namespace constant (default NS_MAIN).
52 * @param string $from Article name we are starting listing at.
53 * @param bool $invert true if we want the namespaces inverted (default false)
55 function namespaceForm ( $namespace = NS_MAIN
, $from = '', $invert ) {
56 global $wgContLang, $wgScript;
57 $t = Title
::makeTitle( NS_SPECIAL
, "Allpages" );
59 $namespaceselect = '<select name="namespace">';
60 $arr = $wgContLang->getNamespaces();
61 foreach ( $arr as $ns => $name ) {
62 if ( $ns < NS_MAIN
) continue;
63 $namespacename = str_replace ( '_', ' ', $name);
64 $n = ($ns == 0) ?
wfMsg ( 'articlenamespace' ) : $namespacename;
65 $sel = ($ns == $namespace) ?
' selected="selected"' : '';
66 $namespaceselect .= "<option value='{$ns}'{$sel}>{$n}</option>";
68 $namespaceselect .= '</select>';
70 $frombox = '<input type="text" size="20" name="from" value="'
71 . htmlspecialchars ( $from ) . '"/>';
72 $submitbutton = '<input type="submit" value="' . wfMsg( 'allpagessubmit' ) . '" />';
74 $invertbox = "<input type='checkbox' name='invert' value='1'" . ( $invert ?
' checked="checked"' : '' ) . ' />';
76 $out = "<div class='namespaceselector'><form method='get' action='{$wgScript}'>";
77 $out .= '<input type="hidden" name="title" value="'.$t->getPrefixedText().'" />';
78 $out .= wfMsg ( 'allpagesformtext', $frombox, $namespaceselect, $submitbutton, $invertbox );
79 $out .= '</form></div>';
84 * @param integer $namespace (default NS_MAIN)
85 * @param bool $invert true if we want the namespaces inverted (default false)
87 function indexShowToplevel ( $namespace = NS_MAIN
, $invert ) {
88 global $wgOut, $indexMaxperpage, $toplevelMaxperpage, $wgContLang, $wgRequest, $wgUser;
89 $sk = $wgUser->getSkin();
90 $fname = "indexShowToplevel";
92 # TODO: Either make this *much* faster or cache the title index points
93 # in the querycache table.
95 $dbr =& wfGetDB( DB_SLAVE
);
96 $page = $dbr->tableName( 'page' );
97 $fromwhere = "FROM $page WHERE page_namespace" .
98 ($invert ?
'!' : '') . "=$namespace";
99 $order_arr = array ( 'ORDER BY' => 'page_title' );
100 $order_str = 'ORDER BY page_title';
102 $where = array( 'page_namespace' => $namespace );
104 $count = $dbr->selectField( 'page', 'COUNT(*)', $where, $fname );
105 $sections = ceil( $count / $indexMaxperpage );
107 if ( $sections < 3 ) {
108 # If there are only two or less sections, don't even display them.
109 # Instead, display the first section directly.
110 indexShowChunk( $namespace, '', $invert );
114 # We want to display $toplevelMaxperpage lines starting at $offset.
115 # NOTICE: $offset starts at 0
116 $offset = intval ( $wgRequest->getVal( 'offset' ) );
117 if ( $offset < 0 ) { $offset = 0; }
118 if ( $offset >= $sections ) { $offset = $sections - 1; }
120 # Where to stop? Notice that this can take the value of $sections, but $offset can't, because if
121 # we're displaying only the very last section, we still need two DB queries to find the titles
122 $stopat = ( $offset +
$toplevelMaxperpage < $sections )
123 ?
$offset +
$toplevelMaxperpage : $sections ;
125 # This array is going to hold the page_titles in order.
128 # If we are going to show n rows, we need n+1 queries to find the relevant titles.
129 for ( $i = $offset; $i <= $stopat; ++
$i ) {
130 if ( $i == $sections ) # if we're displaying the last section, we need to
131 $from = $count-1; # find the last page_title in the DB
132 else if ( $i > $offset )
133 $from = $i * $indexMaxperpage - 1;
135 $from = $i * $indexMaxperpage;
136 $limit = ( $i == $offset ||
$i == $stopat ) ?
1 : 2;
137 $sql = "SELECT page_title $fromwhere $order_str " . $dbr->limitResult ( $limit, $from );
138 $res = $dbr->query( $sql, $fname );
139 $s = $dbr->fetchObject( $res );
140 array_push ( $lines, $s->page_title
);
141 if ( $s = $dbr->fetchObject( $res ) ) {
142 array_push ( $lines, $s->page_title
);
144 $dbr->freeResult( $res );
147 # At this point, $lines should contain an even number of elements.
148 $out .= "<table style='background: inherit;'>";
149 while ( count ( $lines ) > 0 ) {
150 $inpoint = array_shift ( $lines );
151 $outpoint = array_shift ( $lines );
152 $out .= indexShowline ( $inpoint, $outpoint, $namespace, $invert );
156 $nsForm = namespaceForm ( $namespace, '', $invert );
161 $morelinks = $sk->makeKnownLink (
162 $wgContLang->specialPage ( 'Allpages' ),
163 wfMsg ( 'allpagesprev' ),
164 ( $offset > $toplevelMaxperpage ) ?
'offset='.($offset-$toplevelMaxperpage) : ''
167 if ( $stopat < $sections-1 ) {
168 if ( $morelinks != '' ) { $morelinks .= " | "; }
169 $morelinks .= $sk->makeKnownLink (
170 $wgContLang->specialPage ( 'Allpages' ),
171 wfMsg ( 'allpagesnext' ),
172 'offset=' . ($offset +
$toplevelMaxperpage)
176 if ( $morelinks != '' ) {
177 $out2 = '<table style="background: inherit;" width="100%" cellpadding="0" cellspacing="0" border="0">';
178 $out2 .= '<tr valign="top"><td align="left">' . $nsForm;
179 $out2 .= '</td><td align="right" style="font-size: smaller; margin-bottom: 1em;">';
180 $out2 .= $morelinks . '</td></tr></table><hr />';
182 $out2 = $nsForm . '<hr />';
185 $wgOut->addHtml( $out2 . $out );
190 * @param string $from
191 * @param integer $namespace (Default NS_MAIN)
192 * @param bool $invert true if we want the namespaces inverted (default false)
194 function indexShowline( $inpoint, $outpoint, $namespace = NS_MAIN
, $invert ) {
195 global $wgOut, $wgLang, $wgUser;
196 $sk = $wgUser->getSkin();
197 $dbr =& wfGetDB( DB_SLAVE
);
199 $inpointf = htmlspecialchars( str_replace( '_', ' ', $inpoint ) );
200 $outpointf = htmlspecialchars( str_replace( '_', ' ', $outpoint ) );
201 $queryparams = ($namespace ?
"namespace=$namespace" : '') . ($invert ?
"&invert=$invert" : '');
202 $special = Title
::makeTitle( NS_SPECIAL
, 'Allpages/' . $inpoint );
203 $link = $special->escapeLocalUrl( $queryparams );
207 "<a href=\"$link\">$inpointf</a></td><td><a href=\"$link\">",
208 "</a></td><td align=\"left\"><a href=\"$link\">$outpointf</a>"
210 return '<tr><td align="right">'.$out.'</td></tr>';
214 * @param integer $namespace (Default NS_MAIN)
215 * @param string $from list all pages from this name (default FALSE)
216 * @param bool $invert true if we want the namespaces inverted (default false)
218 function indexShowChunk( $namespace = NS_MAIN
, $from, $invert ) {
219 global $wgOut, $wgUser, $indexMaxperpage, $wgContLang;
220 $sk = $wgUser->getSkin();
221 $maxPlusOne = $indexMaxperpage +
1;
224 $dbr =& wfGetDB( DB_SLAVE
);
225 $page = $dbr->tableName( 'page' );
227 $fromTitle = Title
::newFromURL( $from );
228 $fromKey = is_null( $fromTitle ) ?
'' : $fromTitle->getDBkey();
230 $sql = "SELECT page_namespace, page_title FROM $page WHERE page_namespace" .
231 ($invert ?
'!' : '') . "=$namespace" .
232 " AND page_title >= ". $dbr->addQuotes( $fromKey ) .
233 " ORDER BY page_title LIMIT " . $maxPlusOne;
234 $res = $dbr->query( $sql, 'indexShowChunk' );
236 ### FIXME: side link to previous
239 $out = '<table style="background: inherit;" border="0" width="100%">';
240 while( ($n < $indexMaxperpage) && ($s = $dbr->fetchObject( $res )) ) {
241 $t = Title
::makeTitle( $s->page_namespace
, $s->page_title
);
243 $link = $sk->makeKnownLinkObj( $t, $t->getText() );
245 $link = '[[' . htmlspecialchars( $s->page_title
) . ']]';
250 $out .= "<td>$link</td>";
256 if( ($n %
3) != 0 ) {
261 $nsForm = namespaceForm ( $namespace, $from, $invert );
262 $out2 = '<table style="background: inherit;" width="100%" cellpadding="0" cellspacing="0" border="0">';
263 $out2 .= '<tr valign="top"><td align="left">' . $nsForm;
264 $out2 .= '</td><td align="right" style="font-size: smaller; margin-bottom: 1em;">' .
265 $sk->makeKnownLink( $wgContLang->specialPage( "Allpages" ),
266 wfMsg ( 'allpages' ) );
267 if ( ($n == $indexMaxperpage) && ($s = $dbr->fetchObject( $res )) ) {
268 $namespaceparam = $namespace ?
"&namespace=$namespace" : "";
269 $invertparam = $invert ?
"&invert=$invert" : '';
270 $out2 .= " | " . $sk->makeKnownLink(
271 $wgContLang->specialPage( "Allpages" ),
272 wfMsg ( 'nextpage', $s->page_title
),
273 "from=" . wfUrlEncode ( $s->page_title
) . $namespaceparam . $invertparam );
275 $out2 .= "</td></tr></table><hr />";
277 $wgOut->addHtml( $out2 . $out );